FOLLOW US
11 - 12 Jul, 2022
Good Distribution Practice training (GDP)

For the Georgian biopharmaceutical cluster members was held a two-day training on the Good Distribution Practice  (GDP).

GDP is a globally recognized standard that helps pharmaceutical companies ensure the safe supply of medicines to the market.
The training was conducted taking into account the feedback received during the organized (GMP) training in May 2022.

The training was held for the Georgian biopharmaceutical cluster, which brings together both bacteriophage and herbal pharmaceutical companies and their supporting institutions and aims to help members develop competitiveness, increase sales and gain access to new markets.

The training program was organized under the UN Joint Program on Innovative Action for Private Sector Competitiveness in Georgia. The program is funded by the European Union (EU) with a budget of USD 6 million and implemented by four UN agencies – the United Nations Development Programme (UNDP), the Food and Agriculture Organization of the United Nations (FAO), the United Nations Industrial Development Organization (UNIDO) and the International Organization for Migration (IOM).

The training was led by both local and international highly qualified experts and with the involvement of 25 members of pharmaceutical companies. the program received great interest and feedback from the beneficiaries, and the European Union and (UNIDO) will continue to support the Georgian biopharmaceutical cluster in the future in various directions.

This website has been produced with the assistance of the European Union (EU) and the United Nations Industrial Development Organization (UNIDO). Its content is the sole responsibility of The Georgian Biopharmaceutical Cluster and do not necessarily reflect the views of the European Union and the United Nations Industrial Development Organization
8.1.32PHP Version4.44sRequest Duration23MBMemory UsageGET {locale?}/{all}Route
  • warninglog[14:26:38] LOG.warning: strip_tags(): Passing null to parameter #1 ($string) of type string is depre...
  • Booting (368ms)
  • Application (4.06s)
  • 1 x Application (91.61%)
    4.06s
    1 x Booting (8.29%)
    367.69ms
    8 templates were rendered
    • website.pages.news.show (resources/views/website/pages/news/show.blade.php)21blade
      Params
      0
      model
      1
      section
      2
      post
      3
      breadcrumbs
      4
      language_slugs
      5
      teams_section_post
      6
      teams
      7
      projects
      8
      services
      9
      about_section
      10
      contact
      11
      photo
      12
      news
      13
      partners
      14
      members
      15
      board
      16
      sections
      17
      footerSections
      18
      mainBanner
      19
      cardBanner
      20
      sidebar_menu
    • website.layout (resources/views/website/layout.blade.php)28blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      model
      4
      section
      5
      post
      6
      breadcrumbs
      7
      language_slugs
      8
      teams_section_post
      9
      teams
      10
      projects
      11
      services
      12
      about_section
      13
      contact
      14
      photo
      15
      news
      16
      partners
      17
      members
      18
      board
      19
      sections
      20
      footerSections
      21
      mainBanner
      22
      cardBanner
      23
      sidebar_menu
      24
      __currentLoopData
      25
      breadcrumb
      26
      loop
      27
      image
    • website.master (resources/views/website/master.blade.php)28blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      model
      4
      section
      5
      post
      6
      breadcrumbs
      7
      language_slugs
      8
      teams_section_post
      9
      teams
      10
      projects
      11
      services
      12
      about_section
      13
      contact
      14
      photo
      15
      news
      16
      partners
      17
      members
      18
      board
      19
      sections
      20
      footerSections
      21
      mainBanner
      22
      cardBanner
      23
      sidebar_menu
      24
      __currentLoopData
      25
      breadcrumb
      26
      loop
      27
      image
    • website.components.head (resources/views/website/components/head.blade.php)28blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      model
      4
      section
      5
      post
      6
      breadcrumbs
      7
      language_slugs
      8
      teams_section_post
      9
      teams
      10
      projects
      11
      services
      12
      about_section
      13
      contact
      14
      photo
      15
      news
      16
      partners
      17
      members
      18
      board
      19
      sections
      20
      footerSections
      21
      mainBanner
      22
      cardBanner
      23
      sidebar_menu
      24
      __currentLoopData
      25
      breadcrumb
      26
      loop
      27
      image
    • website.components.header (resources/views/website/components/header.blade.php)28blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      model
      4
      section
      5
      post
      6
      breadcrumbs
      7
      language_slugs
      8
      teams_section_post
      9
      teams
      10
      projects
      11
      services
      12
      about_section
      13
      contact
      14
      photo
      15
      news
      16
      partners
      17
      members
      18
      board
      19
      sections
      20
      footerSections
      21
      mainBanner
      22
      cardBanner
      23
      sidebar_menu
      24
      __currentLoopData
      25
      breadcrumb
      26
      loop
      27
      image
    • website.components.FooterBanner (resources/views/website/components/FooterBanner.blade.php)31blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      model
      4
      section
      5
      post
      6
      breadcrumbs
      7
      language_slugs
      8
      teams_section_post
      9
      teams
      10
      projects
      11
      services
      12
      about_section
      13
      contact
      14
      photo
      15
      news
      16
      partners
      17
      members
      18
      board
      19
      sections
      20
      footerSections
      21
      mainBanner
      22
      cardBanner
      23
      sidebar_menu
      24
      __currentLoopData
      25
      breadcrumb
      26
      loop
      27
      image
      28
      subSec
      29
      value
      30
      k
    • website.components.footer (resources/views/website/components/footer.blade.php)31blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      model
      4
      section
      5
      post
      6
      breadcrumbs
      7
      language_slugs
      8
      teams_section_post
      9
      teams
      10
      projects
      11
      services
      12
      about_section
      13
      contact
      14
      photo
      15
      news
      16
      partners
      17
      members
      18
      board
      19
      sections
      20
      footerSections
      21
      mainBanner
      22
      cardBanner
      23
      sidebar_menu
      24
      __currentLoopData
      25
      breadcrumb
      26
      loop
      27
      image
      28
      subSec
      29
      value
      30
      k
    • website.components.scripts (resources/views/website/components/scripts.blade.php)31blade
      Params
      0
      __env
      1
      app
      2
      errors
      3
      model
      4
      section
      5
      post
      6
      breadcrumbs
      7
      language_slugs
      8
      teams_section_post
      9
      teams
      10
      projects
      11
      services
      12
      about_section
      13
      contact
      14
      photo
      15
      news
      16
      partners
      17
      members
      18
      board
      19
      sections
      20
      footerSections
      21
      mainBanner
      22
      cardBanner
      23
      sidebar_menu
      24
      __currentLoopData
      25
      breadcrumb
      26
      loop
      27
      image
      28
      subSec
      29
      value
      30
      k
    uri
    GET {locale?}/{all}
    middleware
    locale, web
    controller
    App\Http\Controllers\Website\RoutesController@index
    namespace
    prefix
    {locale?}
    where
    file
    App/Http/Controllers/Website/RoutesController.php:13-39
    212 statements were executed, 170 of which were duplicated, 42 unique344ms
    • select * from `slugs` where `fullSlug` = 'en/training-gdp' limit 1
      7.48ms/App/Http/Controllers/Website/RoutesController.php:17pharmacl_phar
      Metadata
      Bindings
      • 0. en/training-gdp
      Backtrace
      • 15. /App/Http/Controllers/Website/RoutesController.php:17
      • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `posts` where `posts`.`id` = 178 limit 1
      1.22ms/App/Http/Controllers/Website/RoutesController.php:23pharmacl_phar
      Metadata
      Bindings
      • 0. 178
      Backtrace
      • 19. /App/Http/Controllers/Website/RoutesController.php:23
      • 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
    • select * from `post_translations` where `post_translations`.`post_id` = 178 and `post_translations`.`post_id` is not null
      1.51ms/App/Models/Post.php:106pharmacl_phar
      Metadata
      Bindings
      • 0. 178
      Backtrace
      • 18. /App/Models/Post.php:106
      • 20. /App/Models/Post.php:113
      • 21. /App/Http/Controllers/Website/PagesController.php:398
      • 22. /App/Http/Controllers/Website/RoutesController.php:31
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
    • select * from `slugs` where `slugable_type` = 'App\Models\Post' and `slugable_id` = 178 and `locale` = 'en' limit 1
      1.53ms/App/Models/Post.php:67pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Post
      • 1. 178
      • 2. en
      Backtrace
      • 15. /App/Models/Post.php:67
      • 16. /App/Http/Controllers/Website/PagesController.php:406
      • 17. /App/Http/Controllers/Website/RoutesController.php:31
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
    • select * from `sections` where `id` = 92 limit 1
      1.32ms/App/Http/Controllers/Website/PagesController.php:410pharmacl_phar
      Metadata
      Bindings
      • 0. 92
      Backtrace
      • 15. /App/Http/Controllers/Website/PagesController.php:410
      • 16. /App/Http/Controllers/Website/RoutesController.php:31
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `section_translations` where `section_translations`.`section_id` in (92)
      1.32ms/App/Http/Controllers/Website/PagesController.php:410pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:410
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 92 and `locale` = 'en' limit 1
      1.48ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 92
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. /App/Http/Controllers/Website/PagesController.php:413
      • 17. /App/Http/Controllers/Website/RoutesController.php:31
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
    • select * from `posts` where `section_id` = 178 and `active_on_home` = 1
      1.55ms/App/Http/Controllers/Website/PagesController.php:419pharmacl_phar
      Metadata
      Bindings
      • 0. 178
      • 1. 1
      Backtrace
      • 14. /App/Http/Controllers/Website/PagesController.php:419
      • 15. /App/Http/Controllers/Website/RoutesController.php:31
      • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select `posts`.*, `post_translations`.`text`, `post_translations`.`desc`, `post_translations`.`title`, `post_translations`.`locale_additional`, `post_translations`.`slug` from `posts` inner join `post_translations` on `posts`.`id` = `post_translations`.`post_id` where `posts`.`id` = 178 and `post_translations`.`locale` = 'en' limit 1
      2.23ms/App/Http/Controllers/Website/PagesController.php:428pharmacl_phar
      Metadata
      Bindings
      • 0. 178
      • 1. en
      Backtrace
      • 15. /App/Http/Controllers/Website/PagesController.php:428
      • 16. /App/Http/Controllers/Website/RoutesController.php:31
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `post_files` where `post_files`.`post_id` in (178)
      3.93ms/App/Http/Controllers/Website/PagesController.php:428pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:428
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `sections` where `id` = 92 limit 1
      1.19ms/App/Http/Controllers/Website/PagesController.php:431pharmacl_phar
      Metadata
      Bindings
      • 0. 92
      Backtrace
      • 15. /App/Http/Controllers/Website/PagesController.php:431
      • 16. /App/Http/Controllers/Website/RoutesController.php:31
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `section_translations` where `section_translations`.`section_id` in (92)
      1.09ms/App/Http/Controllers/Website/PagesController.php:431pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:431
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `posts` where `posts`.`section_id` in (92) order by `date` desc
      1.27ms/App/Http/Controllers/Website/PagesController.php:431pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:431
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `post_translations` where `post_translations`.`post_id` in (177, 178, 179, 180, 181, 195, 213, 446) and `locale` = 'en'
      1.44ms/App/Http/Controllers/Website/PagesController.php:431pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 25. /App/Http/Controllers/Website/PagesController.php:431
      • 26. /App/Http/Controllers/Website/RoutesController.php:31
      • 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `sections` where `id` = 92 limit 1
      1.05ms/App/Http/Controllers/Website/PagesController.php:432pharmacl_phar
      Metadata
      Bindings
      • 0. 92
      Backtrace
      • 15. /App/Http/Controllers/Website/PagesController.php:432
      • 16. /App/Http/Controllers/Website/RoutesController.php:31
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `section_translations` where `section_translations`.`section_id` in (92)
      1.38ms/App/Http/Controllers/Website/PagesController.php:432pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:432
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `posts` where `posts`.`section_id` in (92) order by `date` desc
      1.61ms/App/Http/Controllers/Website/PagesController.php:432pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:432
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `post_translations` where `post_translations`.`post_id` in (177, 178, 179, 180, 181, 195, 213, 446) and `locale` = 'en'
      1.75ms/App/Http/Controllers/Website/PagesController.php:432pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 25. /App/Http/Controllers/Website/PagesController.php:432
      • 26. /App/Http/Controllers/Website/RoutesController.php:31
      • 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `sections` where `type_id` = 7 limit 1
      1.37ms/App/Http/Controllers/Website/PagesController.php:433pharmacl_phar
      Metadata
      Bindings
      • 0. 7
      Backtrace
      • 15. /App/Http/Controllers/Website/PagesController.php:433
      • 16. /App/Http/Controllers/Website/RoutesController.php:31
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `sections` where `type_id` = 6 limit 1
      1.14ms/App/Http/Controllers/Website/PagesController.php:434pharmacl_phar
      Metadata
      Bindings
      • 0. 6
      Backtrace
      • 15. /App/Http/Controllers/Website/PagesController.php:434
      • 16. /App/Http/Controllers/Website/RoutesController.php:31
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `sections` where `type_id` = 3 limit 1
      1.42ms/App/Http/Controllers/Website/PagesController.php:435pharmacl_phar
      Metadata
      Bindings
      • 0. 3
      Backtrace
      • 15. /App/Http/Controllers/Website/PagesController.php:435
      • 16. /App/Http/Controllers/Website/RoutesController.php:31
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `section_translations` where `section_translations`.`section_id` in (32)
      1.61ms/App/Http/Controllers/Website/PagesController.php:435pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:435
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `posts` where `posts`.`section_id` in (32) order by `date` desc
      1.45ms/App/Http/Controllers/Website/PagesController.php:435pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:435
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `post_translations` where `post_translations`.`post_id` in (65) and `locale` = 'en'
      1.64ms/App/Http/Controllers/Website/PagesController.php:435pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 25. /App/Http/Controllers/Website/PagesController.php:435
      • 26. /App/Http/Controllers/Website/RoutesController.php:31
      • 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `sections` where `type_id` = 4 limit 1
      1.55ms/App/Http/Controllers/Website/PagesController.php:436pharmacl_phar
      Metadata
      Bindings
      • 0. 4
      Backtrace
      • 15. /App/Http/Controllers/Website/PagesController.php:436
      • 16. /App/Http/Controllers/Website/RoutesController.php:31
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `section_translations` where `section_translations`.`section_id` in (90)
      1.62ms/App/Http/Controllers/Website/PagesController.php:436pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:436
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `posts` where `posts`.`section_id` in (90) order by `date` desc
      1.44ms/App/Http/Controllers/Website/PagesController.php:436pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:436
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `post_translations` where `post_translations`.`post_id` in (158) and `locale` = 'en'
      1.68ms/App/Http/Controllers/Website/PagesController.php:436pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 25. /App/Http/Controllers/Website/PagesController.php:436
      • 26. /App/Http/Controllers/Website/RoutesController.php:31
      • 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `sections` where `type_id` = 2 limit 1
      1.23ms/App/Http/Controllers/Website/PagesController.php:437pharmacl_phar
      Metadata
      Bindings
      • 0. 2
      Backtrace
      • 15. /App/Http/Controllers/Website/PagesController.php:437
      • 16. /App/Http/Controllers/Website/RoutesController.php:31
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `section_translations` where `section_translations`.`section_id` in (81)
      1.28ms/App/Http/Controllers/Website/PagesController.php:437pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:437
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `posts` where `posts`.`section_id` in (81) order by `date` desc
      1.9ms/App/Http/Controllers/Website/PagesController.php:437pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:437
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `post_translations` where `post_translations`.`post_id` in (123, 196, 197, 435, 445, 448, 449) and `locale` = 'en'
      2.24ms/App/Http/Controllers/Website/PagesController.php:437pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 25. /App/Http/Controllers/Website/PagesController.php:437
      • 26. /App/Http/Controllers/Website/RoutesController.php:31
      • 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `sections` where `id` = 92 limit 1
      1.63ms/App/Http/Controllers/Website/PagesController.php:438pharmacl_phar
      Metadata
      Bindings
      • 0. 92
      Backtrace
      • 15. /App/Http/Controllers/Website/PagesController.php:438
      • 16. /App/Http/Controllers/Website/RoutesController.php:31
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `section_translations` where `section_translations`.`section_id` in (92)
      1.73ms/App/Http/Controllers/Website/PagesController.php:438pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:438
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `posts` where `posts`.`section_id` in (92) order by `date` desc
      1.83ms/App/Http/Controllers/Website/PagesController.php:438pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:438
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `post_translations` where `post_translations`.`post_id` in (177, 178, 179, 180, 181, 195, 213, 446) and `locale` = 'en'
      2.19ms/App/Http/Controllers/Website/PagesController.php:438pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 25. /App/Http/Controllers/Website/PagesController.php:438
      • 26. /App/Http/Controllers/Website/RoutesController.php:31
      • 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `sections` where `type_id` = 15 limit 1
      1.55ms/App/Http/Controllers/Website/PagesController.php:439pharmacl_phar
      Metadata
      Bindings
      • 0. 15
      Backtrace
      • 15. /App/Http/Controllers/Website/PagesController.php:439
      • 16. /App/Http/Controllers/Website/RoutesController.php:31
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `section_translations` where `section_translations`.`section_id` in (87)
      1.66ms/App/Http/Controllers/Website/PagesController.php:439pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:439
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `posts` where `posts`.`section_id` in (87) order by `date` desc
      1.61ms/App/Http/Controllers/Website/PagesController.php:439pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:439
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `post_translations` where `post_translations`.`post_id` in (145, 154) and `locale` = 'en'
      1.8ms/App/Http/Controllers/Website/PagesController.php:439pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 25. /App/Http/Controllers/Website/PagesController.php:439
      • 26. /App/Http/Controllers/Website/RoutesController.php:31
      • 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `sections` where `type_id` = 17 and `id` = 92 limit 1
      1.59ms/App/Http/Controllers/Website/PagesController.php:440pharmacl_phar
      Metadata
      Bindings
      • 0. 17
      • 1. 92
      Backtrace
      • 15. /App/Http/Controllers/Website/PagesController.php:440
      • 16. /App/Http/Controllers/Website/RoutesController.php:31
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `sections` where `type_id` = 9 limit 1
      1.56ms/App/Http/Controllers/Website/PagesController.php:441pharmacl_phar
      Metadata
      Bindings
      • 0. 9
      Backtrace
      • 15. /App/Http/Controllers/Website/PagesController.php:441
      • 16. /App/Http/Controllers/Website/RoutesController.php:31
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `section_translations` where `section_translations`.`section_id` in (78)
      1.33ms/App/Http/Controllers/Website/PagesController.php:441pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:441
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `posts` where `posts`.`section_id` in (78) order by `date` desc
      1.36ms/App/Http/Controllers/Website/PagesController.php:441pharmacl_phar
      Metadata
      Backtrace
      • 20. /App/Http/Controllers/Website/PagesController.php:441
      • 21. /App/Http/Controllers/Website/RoutesController.php:31
      • 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `post_translations` where `post_translations`.`post_id` in (116, 163) and `locale` = 'en'
      1.35ms/App/Http/Controllers/Website/PagesController.php:441pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 25. /App/Http/Controllers/Website/PagesController.php:441
      • 26. /App/Http/Controllers/Website/RoutesController.php:31
      • 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • update `posts` set `views` = 1730, `posts`.`updated_at` = '2025-07-25 14:26:37' where `id` = 178
      4.16ms/App/Http/Controllers/Website/PagesController.php:445pharmacl_phar
      Metadata
      Bindings
      • 0. 1730
      • 1. 2025-07-25 14:26:37
      • 2. 178
      Backtrace
      • 13. /App/Http/Controllers/Website/PagesController.php:445
      • 14. /App/Http/Controllers/Website/RoutesController.php:31
      • 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) and exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1) and `parent_id` is null order by `order` asc, `created_at` desc
      2.38ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 1
      • 3. 1
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:36
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (32, 84, 90, 91, 93, 102, 104) and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) order by `order` asc, `order` asc, `created_at` desc
      1.59ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) and `locale` = 'en'
      1.33ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`id` in (32, 84, 91, 93, 102, 104)
      1.02ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where 0 = 1
      760μs/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 29. /App/Http/View/Composers/WebsiteComposer.php:36
      • 31. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 32. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 33. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 34. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) order by `order` asc
      830μs/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.18ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `menu_sections` where `menu_sections`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      960μs/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 2) order by `order` asc
      1.79ms/App/Http/View/Composers/WebsiteComposer.php:45pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 2
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:45
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 1 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` asc
      1.25ms/App/Http/View/Composers/WebsiteComposer.php:52pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:52
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 3 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` desc, `date` desc
      1.77ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. 3
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:62
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banner_translations` where `locale` = 'en' and `banner_translations`.`banner_id` in (28, 29, 30, 31)
      1.41ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:62
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `post_translations` where `post_translations`.`post_id` = 178 and `post_translations`.`post_id` is not null
      1.25ms/App/Models/Post.php:106pharmacl_phar
      Metadata
      Bindings
      • 0. 178
      Backtrace
      • 18. /App/Models/Post.php:106
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:317
      • 23. view::dacfb6f22dc64083a76cc3ce8a8bc2927acd17bd:31
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) and exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1) and `parent_id` is null order by `order` asc, `created_at` desc
      2.51ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 1
      • 3. 1
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:36
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (32, 84, 90, 91, 93, 102, 104) and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) order by `order` asc, `order` asc, `created_at` desc
      1.63ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) and `locale` = 'en'
      1.58ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`id` in (32, 84, 91, 93, 102, 104)
      1.04ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where 0 = 1
      770μs/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 29. /App/Http/View/Composers/WebsiteComposer.php:36
      • 31. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 32. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 33. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 34. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) order by `order` asc
      1.14ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.23ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `menu_sections` where `menu_sections`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      890μs/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 2) order by `order` asc
      1.74ms/App/Http/View/Composers/WebsiteComposer.php:45pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 2
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:45
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 1 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` asc
      1.25ms/App/Http/View/Composers/WebsiteComposer.php:52pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:52
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 3 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` desc, `date` desc
      1.23ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. 3
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:62
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banner_translations` where `locale` = 'en' and `banner_translations`.`banner_id` in (28, 29, 30, 31)
      980μs/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:62
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) and exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1) and `parent_id` is null order by `order` asc, `created_at` desc
      1.93ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 1
      • 3. 1
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:36
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (32, 84, 90, 91, 93, 102, 104) and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) order by `order` asc, `order` asc, `created_at` desc
      1.45ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) and `locale` = 'en'
      1.31ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`id` in (32, 84, 91, 93, 102, 104)
      900μs/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where 0 = 1
      720μs/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 29. /App/Http/View/Composers/WebsiteComposer.php:36
      • 31. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 32. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 33. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 34. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) order by `order` asc
      1.07ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.15ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `menu_sections` where `menu_sections`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      870μs/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 2) order by `order` asc
      2.12ms/App/Http/View/Composers/WebsiteComposer.php:45pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 2
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:45
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 1 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` asc
      1.67ms/App/Http/View/Composers/WebsiteComposer.php:52pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:52
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 3 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` desc, `date` desc
      1.87ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. 3
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:62
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banner_translations` where `locale` = 'en' and `banner_translations`.`banner_id` in (28, 29, 30, 31)
      1.42ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:62
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) and exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1) and `parent_id` is null order by `order` asc, `created_at` desc
      2.63ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 1
      • 3. 1
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:36
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (32, 84, 90, 91, 93, 102, 104) and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) order by `order` asc, `order` asc, `created_at` desc
      1.98ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) and `locale` = 'en'
      1.71ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`id` in (32, 84, 91, 93, 102, 104)
      1.24ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where 0 = 1
      1.03ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 29. /App/Http/View/Composers/WebsiteComposer.php:36
      • 31. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 32. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 33. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 34. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) order by `order` asc
      1.47ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.56ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `menu_sections` where `menu_sections`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.26ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 2) order by `order` asc
      2.21ms/App/Http/View/Composers/WebsiteComposer.php:45pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 2
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:45
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 1 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` asc
      1.58ms/App/Http/View/Composers/WebsiteComposer.php:52pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:52
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 3 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` desc, `date` desc
      1.78ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. 3
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:62
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banner_translations` where `locale` = 'en' and `banner_translations`.`banner_id` in (28, 29, 30, 31)
      1.46ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:62
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) and exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1) and `parent_id` is null order by `order` asc, `created_at` desc
      3.95ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 1
      • 3. 1
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:36
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (32, 84, 90, 91, 93, 102, 104) and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) order by `order` asc, `order` asc, `created_at` desc
      2.77ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) and `locale` = 'en'
      2.54ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`id` in (32, 84, 91, 93, 102, 104)
      1.6ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where 0 = 1
      1.32ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 29. /App/Http/View/Composers/WebsiteComposer.php:36
      • 31. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 32. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 33. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 34. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) order by `order` asc
      1.99ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      2.19ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `menu_sections` where `menu_sections`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.65ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 2) order by `order` asc
      3.03ms/App/Http/View/Composers/WebsiteComposer.php:45pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 2
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:45
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 1 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` asc
      2.04ms/App/Http/View/Composers/WebsiteComposer.php:52pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:52
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 3 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` desc, `date` desc
      1.66ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. 3
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:62
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banner_translations` where `locale` = 'en' and `banner_translations`.`banner_id` in (28, 29, 30, 31)
      1.01ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:62
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 32 and `locale` = 'en' limit 1
      1.06ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 32
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:28
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 101 and `locale` = 'en' limit 1
      1.21ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 101
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 115 and `locale` = 'en' limit 1
      1.07ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 115
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 89 and `locale` = 'en' limit 1
      1.15ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 89
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 82 and `locale` = 'en' limit 1
      1.16ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 82
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 111 and `locale` = 'en' limit 1
      1.9ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 111
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 104 and `locale` = 'en' limit 1
      1.8ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 104
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:28
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 103 and `locale` = 'en' limit 1
      1.77ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 103
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 85 and `locale` = 'en' limit 1
      1.73ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 85
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 91 and `locale` = 'en' limit 1
      1.73ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 91
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:28
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 105 and `locale` = 'en' limit 1
      1.46ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 105
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 92 and `locale` = 'en' limit 1
      1.37ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 92
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 93 and `locale` = 'en' limit 1
      1.86ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 93
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:28
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 96 and `locale` = 'en' limit 1
      1.41ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 96
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 97 and `locale` = 'en' limit 1
      1.49ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 97
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 118 and `locale` = 'en' limit 1
      1.45ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 118
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 84 and `locale` = 'en' limit 1
      1.49ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 84
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:28
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 107 and `locale` = 'en' limit 1
      1.49ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 107
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 108 and `locale` = 'en' limit 1
      1.45ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 108
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 81 and `locale` = 'en' limit 1
      1.5ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 81
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 78 and `locale` = 'en' limit 1
      1.43ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 78
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 80 and `locale` = 'en' limit 1
      1.41ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 80
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:34
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 90 and `locale` = 'en' limit 1
      1.45ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 90
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::3ef3f908c57da0316797d86320bb795ad51cf78f:28
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 32 and `locale` = 'en' limit 1
      1.29ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 32
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:152
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 101 and `locale` = 'en' limit 1
      1.46ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 101
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 115 and `locale` = 'en' limit 1
      1.41ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 115
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 89 and `locale` = 'en' limit 1
      1.41ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 89
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 82 and `locale` = 'en' limit 1
      1.32ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 82
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 111 and `locale` = 'en' limit 1
      1.31ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 111
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 104 and `locale` = 'en' limit 1
      1.38ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 104
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:152
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 103 and `locale` = 'en' limit 1
      1.46ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 103
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 85 and `locale` = 'en' limit 1
      1.39ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 85
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 91 and `locale` = 'en' limit 1
      1.43ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 91
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:152
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 105 and `locale` = 'en' limit 1
      1.4ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 105
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 92 and `locale` = 'en' limit 1
      1.42ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 92
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 93 and `locale` = 'en' limit 1
      1.45ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 93
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:152
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 96 and `locale` = 'en' limit 1
      1.46ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 96
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 97 and `locale` = 'en' limit 1
      1.5ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 97
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 118 and `locale` = 'en' limit 1
      1.47ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 118
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 84 and `locale` = 'en' limit 1
      1.47ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 84
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:152
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 107 and `locale` = 'en' limit 1
      1.46ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 107
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 108 and `locale` = 'en' limit 1
      1.5ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 108
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 102 and `locale` = 'en' limit 1
      1.48ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 102
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:152
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 81 and `locale` = 'en' limit 1
      1.58ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 81
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 78 and `locale` = 'en' limit 1
      1.47ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 78
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 80 and `locale` = 'en' limit 1
      1.45ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 80
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:169
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 90 and `locale` = 'en' limit 1
      1.47ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 90
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::de16122d1366c1b5043b7f6635e71127f5e4ca68:152
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) and exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1) and `parent_id` is null order by `order` asc, `created_at` desc
      3.01ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 1
      • 3. 1
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:36
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (32, 84, 90, 91, 93, 102, 104) and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) order by `order` asc, `order` asc, `created_at` desc
      2.14ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) and `locale` = 'en'
      1.91ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`id` in (32, 84, 91, 93, 102, 104)
      1.46ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where 0 = 1
      1.2ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 29. /App/Http/View/Composers/WebsiteComposer.php:36
      • 31. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 32. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 33. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 34. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) order by `order` asc
      1.67ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.69ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `menu_sections` where `menu_sections`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.38ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 2) order by `order` asc
      2.2ms/App/Http/View/Composers/WebsiteComposer.php:45pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 2
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:45
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 1 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` asc
      2.3ms/App/Http/View/Composers/WebsiteComposer.php:52pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:52
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 3 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` desc, `date` desc
      1.78ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. 3
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:62
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banner_translations` where `locale` = 'en' and `banner_translations`.`banner_id` in (28, 29, 30, 31)
      1.41ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:62
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) and exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1) and `parent_id` is null order by `order` asc, `created_at` desc
      2.71ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 1
      • 3. 1
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:36
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (32, 84, 90, 91, 93, 102, 104) and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) order by `order` asc, `order` asc, `created_at` desc
      2.06ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) and `locale` = 'en'
      1.83ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`id` in (32, 84, 91, 93, 102, 104)
      1.37ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where 0 = 1
      1.15ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 29. /App/Http/View/Composers/WebsiteComposer.php:36
      • 31. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 32. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 33. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 34. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) order by `order` asc
      1.88ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.59ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `menu_sections` where `menu_sections`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.3ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 2) order by `order` asc
      3.45ms/App/Http/View/Composers/WebsiteComposer.php:45pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 2
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:45
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 1 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` asc
      1.74ms/App/Http/View/Composers/WebsiteComposer.php:52pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:52
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 3 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` desc, `date` desc
      2ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. 3
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:62
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banner_translations` where `locale` = 'en' and `banner_translations`.`banner_id` in (28, 29, 30, 31)
      1.46ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:62
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 32 and `locale` = 'en' limit 1
      1.38ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 32
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `section_translations` where `section_translations`.`section_id` = 32 and `section_translations`.`section_id` is not null
      1.27ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. 32
      Backtrace
      • 18. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:145
      • 24. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 89 and `locale` = 'en' limit 1
      1.25ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 89
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `section_translations` where `section_translations`.`section_id` = 89 and `section_translations`.`section_id` is not null
      1.35ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. 89
      Backtrace
      • 18. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:145
      • 24. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 82 and `locale` = 'en' limit 1
      1.46ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 82
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `section_translations` where `section_translations`.`section_id` = 82 and `section_translations`.`section_id` is not null
      1.39ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. 82
      Backtrace
      • 18. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:145
      • 24. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 104 and `locale` = 'en' limit 1
      1.62ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 104
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `section_translations` where `section_translations`.`section_id` = 104 and `section_translations`.`section_id` is not null
      1.47ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. 104
      Backtrace
      • 18. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:145
      • 24. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 91 and `locale` = 'en' limit 1
      1.46ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 91
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `section_translations` where `section_translations`.`section_id` = 91 and `section_translations`.`section_id` is not null
      1.46ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. 91
      Backtrace
      • 18. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:145
      • 24. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 92 and `locale` = 'en' limit 1
      1.53ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 92
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `section_translations` where `section_translations`.`section_id` = 92 and `section_translations`.`section_id` is not null
      1.59ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. 92
      Backtrace
      • 18. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:145
      • 24. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 93 and `locale` = 'en' limit 1
      1.69ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 93
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `section_translations` where `section_translations`.`section_id` = 93 and `section_translations`.`section_id` is not null
      1.61ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. 93
      Backtrace
      • 18. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:145
      • 24. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 84 and `locale` = 'en' limit 1
      1.5ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 84
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `section_translations` where `section_translations`.`section_id` = 84 and `section_translations`.`section_id` is not null
      1.63ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. 84
      Backtrace
      • 18. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:145
      • 24. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 81 and `locale` = 'en' limit 1
      1.56ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 81
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `section_translations` where `section_translations`.`section_id` = 81 and `section_translations`.`section_id` is not null
      1.5ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. 81
      Backtrace
      • 18. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:145
      • 24. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 78 and `locale` = 'en' limit 1
      1.55ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 78
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `section_translations` where `section_translations`.`section_id` = 78 and `section_translations`.`section_id` is not null
      1.59ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. 78
      Backtrace
      • 18. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:145
      • 24. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
    • select * from `slugs` where `slugable_type` = 'App\Models\Section' and `slugable_id` = 90 and `locale` = 'en' limit 1
      1.54ms/App/Models/Section.php:72pharmacl_phar
      Metadata
      Bindings
      • 0. App\Models\Section
      • 1. 90
      • 2. en
      Backtrace
      • 15. /App/Models/Section.php:72
      • 16. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
      • 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61
    • select * from `section_translations` where `section_translations`.`section_id` = 90 and `section_translations`.`section_id` is not null
      1.49ms/vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161pharmacl_phar
      Metadata
      Bindings
      • 0. 90
      Backtrace
      • 18. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:161
      • 20. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:435
      • 21. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:196
      • 22. /vendor/astrotomic/laravel-translatable/src/Translatable/Translatable.php:145
      • 24. view::9f141e955adee19c8203a2e3fd3d31a27840ebaf:22
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) and exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1) and `parent_id` is null order by `order` asc, `created_at` desc
      3ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 1
      • 3. 1
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:36
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (32, 84, 90, 91, 93, 102, 104) and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 1) order by `order` asc, `order` asc, `created_at` desc
      2.02ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) and `locale` = 'en'
      1.75ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`id` in (32, 84, 91, 93, 102, 104)
      1.36ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where 0 = 1
      1.16ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 29. /App/Http/View/Composers/WebsiteComposer.php:36
      • 31. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 32. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 33. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 34. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where `sections`.`parent_id` in (78, 80, 81, 82, 85, 89, 92, 96, 97, 101, 103, 105, 107, 108, 111, 115, 118) order by `order` asc
      1.64ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 24. /App/Http/View/Composers/WebsiteComposer.php:36
      • 26. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 27. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 28. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 29. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `section_translations` where `section_translations`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.91ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `menu_sections` where `menu_sections`.`section_id` in (32, 84, 90, 91, 93, 102, 104)
      1.76ms/App/Http/View/Composers/WebsiteComposer.php:36pharmacl_phar
      Metadata
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:36
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `sections` where exists (select * from `section_translations` where `sections`.`id` = `section_translations`.`section_id` and `active` = 1 and `locale` = 'en') and exists (select * from `menu_sections` where `sections`.`id` = `menu_sections`.`section_id` and `menu_type_id` = 2) order by `order` asc
      2.12ms/App/Http/View/Composers/WebsiteComposer.php:45pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. en
      • 2. 2
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:45
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 1 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` asc
      1.47ms/App/Http/View/Composers/WebsiteComposer.php:52pharmacl_phar
      Metadata
      Bindings
      • 0. 1
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:52
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banners` where `type_id` = 3 and exists (select * from `banner_translations` where `banners`.`id` = `banner_translations`.`banner_id` and `active` = 1 and `locale` = 'en') order by `date` desc, `date` desc
      1.69ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. 3
      • 1. 1
      • 2. en
      Backtrace
      • 14. /App/Http/View/Composers/WebsiteComposer.php:62
      • 16. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 17. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 18. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    • select * from `banner_translations` where `locale` = 'en' and `banner_translations`.`banner_id` in (28, 29, 30, 31)
      1.15ms/App/Http/View/Composers/WebsiteComposer.php:62pharmacl_phar
      Metadata
      Bindings
      • 0. en
      Backtrace
      • 19. /App/Http/View/Composers/WebsiteComposer.php:62
      • 21. /vendor/laravel/framework/src/Illuminate/Container/Container.php:921
      • 22. /vendor/laravel/framework/src/Illuminate/Container/Container.php:758
      • 23. /vendor/laravel/framework/src/Illuminate/Foundation/Application.php:851
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:694
    App\Models\BannerTranslation
    32
    App\Models\Banner
    40
    App\Models\MenuSection
    104
    App\Models\PostFile
    5
    App\Models\SectionTranslation
    288
    App\Models\Section
    337
    App\Models\PostTranslation
    41
    App\Models\Post
    39
    App\Models\Slug
    61
        locale
        en
        _token
        7bRkYQ3ZiZPRktKMI09CGsoJaTC72Q9A0HtYksEb
        _previous
        array:1 [ "url" => "https://www.pharmacluster.org/en/training-gdp" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /en/training-gdp
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:15 [ "host" => array:1 [ 0 => "www.pharmacluster.org" ] "priority" => array:1 [ 0 => "u=0, i" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua" => array:1 [ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] ]
        request_server
        0 of 0
        array:75 [ "USER" => "pharmacl" "HOME" => "/home/pharmacl" "SCRIPT_NAME" => "/public/index.php" "REQUEST_URI" => "/en/training-gdp" "QUERY_STRING" => "" "REQUEST_METHOD" => "GET" "SERVER_PROTOCOL" => "HTTP/2.0" "GATEWAY_INTERFACE" => "CGI/1.1" "REDIRECT_URL" => "/public/en/training-gdp" "REMOTE_PORT" => "9321" "SCRIPT_FILENAME" => "/home/pharmacl/domains/pharmacluster.org/private_html/public/index.php" "SERVER_ADMIN" => "webmaster@pharmacluster.org" "CONTEXT_DOCUMENT_ROOT" => "/home/pharmacl/domains/pharmacluster.org/private_html" "CONTEXT_PREFIX" => "" "REQUEST_SCHEME" => "https" "DOCUMENT_ROOT" => "/home/pharmacl/domains/pharmacluster.org/private_html" "REMOTE_ADDR" => "216.73.216.214" "SERVER_PORT" => "443" "SERVER_ADDR" => "91.239.206.137" "SERVER_NAME" => "www.pharmacluster.org" "SERVER_SOFTWARE" => "Apache/2" "SERVER_SIGNATURE" => "" "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin" "HTTP_HOST" => "www.pharmacluster.org" "HTTP_PRIORITY" => "u=0, i" "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_SITE" => "none" "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA" => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_PRAGMA" => "no-cache" "proxy-nokeepalive" => "1" "H2_STREAM_TAG" => "1021498-4285-1" "H2_STREAM_ID" => "1" "H2_PUSHED_ON" => "" "H2_PUSHED" => "" "H2_PUSH" => "off" "H2PUSH" => "off" "HTTP2" => "on" "SSL_TLS_SNI" => "www.pharmacluster.org" "HTTPS" => "on" "UNIQUE_ID" => "aINb3HGdvrfkbov6sK8sGwAAExQ" "REDIRECT_STATUS" => "200" "REDIRECT_H2_STREAM_TAG" => "1021498-4285-1" "REDIRECT_H2_STREAM_ID" => "1" "REDIRECT_H2_PUSHED_ON" => "" "REDIRECT_H2_PUSHED" => "" "REDIRECT_H2_PUSH" => "off" "REDIRECT_H2PUSH" => "off" "REDIRECT_HTTP2" => "on" "REDIRECT_SSL_TLS_SNI" => "www.pharmacluster.org" "REDIRECT_HTTPS" => "on" "REDIRECT_UNIQUE_ID" => "aINb3HGdvrfkbov6sK8sGwAAExQ" "REDIRECT_REDIRECT_STATUS" => "200" "REDIRECT_REDIRECT_H2_STREAM_TAG" => "1021498-4285-1" "REDIRECT_REDIRECT_H2_STREAM_ID" => "1" "REDIRECT_REDIRECT_H2_PUSHED_ON" => "" "REDIRECT_REDIRECT_H2_PUSHED" => "" "REDIRECT_REDIRECT_H2_PUSH" => "off" "REDIRECT_REDIRECT_H2PUSH" => "off" "REDIRECT_REDIRECT_HTTP2" => "on" "REDIRECT_REDIRECT_SSL_TLS_SNI" => "www.pharmacluster.org" "REDIRECT_REDIRECT_HTTPS" => "on" "REDIRECT_REDIRECT_UNIQUE_ID" => "aINb3HGdvrfkbov6sK8sGwAAExQ" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/public/index.php" "REQUEST_TIME_FLOAT" => 1753439196.3157 "REQUEST_TIME" => 1753439196 ]
        request_cookies
        []
        
        response_headers
        0 of 0
        array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Fri, 25 Jul 2025 10:26:40 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InRXUjhtYmFJc05IakVOYnY2RmJLbXc9PSIsInZhbHVlIjoidnUyT1lwa0xkRE92RFRBZGc5Z296OG9QL3hBSUdpY21Ca1ZuRmVWRVQrQVBNNjJTSmpOMmh0N251ZG9rbjM2alRXMm9hRGl3Z3FYOGlJODlGUFFBZnlTd1VheHQvVVZnQktEV2dubzk2NTl0T2FSY3FqM2RXR0dHS29ObzNvRTYiLCJtYWMiOiI5OWYxYzA2NGQ0OTMzZDZlYWE0ZjBlZTEyZGMzNDRkYTAzMTg1MWMxMTI1NzA2ZDIwMzA1NjdhMmQ3YmYyYTQ4IiwidGFnIjoiIn0%3D; expires=Fri, 25-Jul-2025 12:26:40 GMT; Max-Age=7200; path=/; samesite=laxXSRF-TOKEN=eyJpdiI6InRXUjhtYmFJc05IakVOYnY2RmJLbXc9PSIsInZhbHVlIjoidnUyT1lwa0xkRE92RFRBZGc5Z296OG9QL3hBSUdpY21Ca1ZuRmVWRVQrQVBNNjJTSmpOMmh0N251ZG9rbjM2alRXMm9hR" 1 => "geopharmacy_session=eyJpdiI6InlLeWlJaGJMZzBEMkpQejNyK3VUR2c9PSIsInZhbHVlIjoiUnA5MitVRWNzWWd1SExwQVBjUmhYTmpVTGNWVFNVZWxlY1F3M2kyQlVmTE9OdzgxL2Q4WmhGbENoTEZ6cVAzQ0pLeE9IUzNhQ0ZoUVUzRy9VWXR4ZDVGTkh1dGgvRWVLSG4yRGo4NzhwZzBMUjhEREpvSHBpbXBneFpWV2w5dDAiLCJtYWMiOiI2NDg5YWQ3OWFjNDZiMDU4OTIwN2E5ZGI1ZjkzMzc0NTExOWU4YzAyN2IzYjBlMWY3ZGQ0YzJkMDhkODA5OWM3IiwidGFnIjoiIn0%3D; expires=Fri, 25-Jul-2025 12:26:40 GMT; Max-Age=7200; path=/; httponly; samesite=laxgeopharmacy_session=eyJpdiI6InlLeWlJaGJMZzBEMkpQejNyK3VUR2c9PSIsInZhbHVlIjoiUnA5MitVRWNzWWd1SExwQVBjUmhYTmpVTGNWVFNVZWxlY1F3M2kyQlVmTE9OdzgxL2Q4WmhGbENoTEZ6cVAz" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6InRXUjhtYmFJc05IakVOYnY2RmJLbXc9PSIsInZhbHVlIjoidnUyT1lwa0xkRE92RFRBZGc5Z296OG9QL3hBSUdpY21Ca1ZuRmVWRVQrQVBNNjJTSmpOMmh0N251ZG9rbjM2alRXMm9hRGl3Z3FYOGlJODlGUFFBZnlTd1VheHQvVVZnQktEV2dubzk2NTl0T2FSY3FqM2RXR0dHS29ObzNvRTYiLCJtYWMiOiI5OWYxYzA2NGQ0OTMzZDZlYWE0ZjBlZTEyZGMzNDRkYTAzMTg1MWMxMTI1NzA2ZDIwMzA1NjdhMmQ3YmYyYTQ4IiwidGFnIjoiIn0%3D; expires=Fri, 25-Jul-2025 12:26:40 GMT; path=/XSRF-TOKEN=eyJpdiI6InRXUjhtYmFJc05IakVOYnY2RmJLbXc9PSIsInZhbHVlIjoidnUyT1lwa0xkRE92RFRBZGc5Z296OG9QL3hBSUdpY21Ca1ZuRmVWRVQrQVBNNjJTSmpOMmh0N251ZG9rbjM2alRXMm9hR" 1 => "geopharmacy_session=eyJpdiI6InlLeWlJaGJMZzBEMkpQejNyK3VUR2c9PSIsInZhbHVlIjoiUnA5MitVRWNzWWd1SExwQVBjUmhYTmpVTGNWVFNVZWxlY1F3M2kyQlVmTE9OdzgxL2Q4WmhGbENoTEZ6cVAzQ0pLeE9IUzNhQ0ZoUVUzRy9VWXR4ZDVGTkh1dGgvRWVLSG4yRGo4NzhwZzBMUjhEREpvSHBpbXBneFpWV2w5dDAiLCJtYWMiOiI2NDg5YWQ3OWFjNDZiMDU4OTIwN2E5ZGI1ZjkzMzc0NTExOWU4YzAyN2IzYjBlMWY3ZGQ0YzJkMDhkODA5OWM3IiwidGFnIjoiIn0%3D; expires=Fri, 25-Jul-2025 12:26:40 GMT; path=/; httponlygeopharmacy_session=eyJpdiI6InlLeWlJaGJMZzBEMkpQejNyK3VUR2c9PSIsInZhbHVlIjoiUnA5MitVRWNzWWd1SExwQVBjUmhYTmpVTGNWVFNVZWxlY1F3M2kyQlVmTE9OdzgxL2Q4WmhGbENoTEZ6cVAz" ] ]
        session_attributes
        0 of 0
        array:5 [ "locale" => "en" "_token" => "7bRkYQ3ZiZPRktKMI09CGsoJaTC72Q9A0HtYksEb" "_previous" => array:1 [ "url" => "https://www.pharmacluster.org/en/training-gdp" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]